SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review

The competent software architecture plays a crucial role in the difficult task of big data processing for SQL and NoSQL databases. databases were created to organize allow horizontal expansion. databases, on other hand, support scalability can efficiently process large amounts unstructured data. Organizational needs determine which paradigm is appropriate, yet selecting best option not always easy. Differences database design are what set apart. Each type also consistently employs mixed-model approach. Therefore, it challenging cloud users transfer their among different storage services (CSPs). There several paradigms being monitored by various platforms (IaaS, PaaS, SaaS, DBaaS). purpose this SLR examine articles that address portability interoperability, as well architectures Numerous studies comparing capabilities particularly Oracle RDBMS Document Database (MongoDB), terms scale, performance, availability, consistency, sharding, presented part state art. Research indicates with specifically tailored structures, may be analytics, while suited online transaction (OLTP) purposes.